Searching all fields at once

bnashenas1984

Hi everyone
I was wondering if it's possible to search all fields of a table at once.

Let's say we have a table called (articles) :

Expand|Select|Wrap|Line Numbers

 
+ ID +   Name   + Description  +

| 1  | computer | AMD Athlon   |

| 2  | table    | Black painted|

| 3  | Chair    | Orange       |

Then we have a search box which allows users to serach.

Is it possible to serach in both filds (Name , Description) at the same time.
Something like this:

Search text = table painted

Expand|Select|Wrap|Line Numbers

"SELECT * FROM articles WHERE * LIKE '%table%painted%'"

The result should be the second row.

Thanks

Markus

You can use the AND operator to extend your WHERE clause.

Expand|Select|Wrap|Line Numbers

 
SELECT * FROM `articles` WHERE `Name` LIKE '%table%' AND `Description` LIKE `%painted%`;

Mark.

bnashenas1984

Thanks Markus for the reply
It's what i'm doing right now. But I was thinking if it's possible to search the whole row without naming each field.

Like this

Expand|Select|Wrap|Line Numbers

SELECT * FROM articles WHERE (whole row) LIKE "%table%"

Markus

Quote:

Originally Posted by bnashenas1984

Thanks Markus for the reply
It's what i'm doing right now. But I was thinking if it's possible to search the whole row without naming each field.

Like this

Expand|Select|Wrap|Line Numbers

SELECT * FROM articles WHERE (whole row) LIKE "%table%"

Not that I know of.

Mark.

Searching all fields at once

re: Searching all fields at once

re: Searching all fields at once

re: Searching all fields at once

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about