Database Searching...?

[gilly914]

Ok, I know that this is very similiar to the previous question... but i don;t think it is the same question... or i just didn't understand the previous question...

Anyway.. It goes like this...
I have a database with lots of items and there is a column called "Descrip" - which holds the description of the item...
I want the user to be able to search for a certain word, and get the rows of every item with that word in the description...

How do i go about doing this?

10X, gilly914

[Norby mahoney]

Ok, I know that this is very similiar to the previous question... but i don;t think it is the same question... or i just didn't understand the previous question...

Anyway.. It goes like this...
I have a database with lots of items and there is a column called "Descrip" - which holds the description of the item...
I want the user to be able to search for a certain word, and get the rows of every item with that word in the description...

How do i go about doing this?

10X, gilly914

If the user chooses to search for a records that have the work XYZ in the Descrip field, this would be your query:
SELECT * FROM table WHERE table.Descrip LIKE '%XYZ%'

This works in SQL Server/MSDE. For MS Access, replace the '%' with '*'.
It compiles in Oracle (with either '%' or '*'), but I not sure which one will
give the correct results.

[gilly914]

But how do i do this with MySQL???
the same?

ill try...