PHP find (whatever)

Hi all,

How to make a script that will find data in a cell from a MySQL database. I
mean:

SELECT FROM database WHERE (whatever)
So searching has to go on ALL rows and coloms.

Thanks in advance
Richard.

Richard Farla wrote:

> Hi all,
>
> How to make a script that will find data in a cell from a MySQL database.
> I mean:
>
> SELECT FROM database WHERE (whatever)
> So searching has to go on ALL rows and coloms.
>
> Thanks in advance
> Richard.

Normalize your data. It's a database not a spreadsheet.

C.

"Richard Farla" <farla-klep@planet.nl> wrote in message
news:cel7n6$7du$2@reader08.wxs.nl...
> Hi all,
>
> How to make a script that will find data in a cell from a MySQL database.
I
> mean:
>
> SELECT FROM database WHERE (whatever)
> So searching has to go on ALL rows and coloms.
>

See http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html

- Virgil

Richard Farla wrote:
> Hi all,
>
> How to make a script that will find data in a cell from a MySQL database. I
> mean:
>
> SELECT FROM database WHERE (whatever)
> So searching has to go on ALL rows and coloms.
>
> Thanks in advance
> Richard.
>
>
>
You should try
SELECT * FROM database WHERE (whatever)
Robert