How to create this SQL Query?

Hi Folks,

I want to Query the database (3 fields)  and find all matches for a particular word. I want to search both the name, website and the category field for this word.

Example:

If I query for the word jenna it shoudl return all records of which either the name, website or category contains the word jenna.

If you need more info please ask. Im using phpMyAdmin

Regards Dweep

Ps a next step will be to convert this into php code and use a textbox so the user can search the database for whatever word he wants and get the results displayed.
SELECT *
FROM `adressen`
WHERE `name` = "jenna"

Open in new window

PeterdeBAsked:
Who is Participating?
 
shobinsunConnect With a Mentor Commented:
Hello,

use:

SELECT * FROM `adressen` WHERE `name` like "%jenna%" or 'website' like "%jenna%" or category' like "%jenna%"

Its more correct.

Regards.
0
 
twocandlesCommented:
try this:


SELECT *
FROM `adressen`
WHERE `name` like "jenna"
or 'website' like "jenna"
or 'category' like "jenna"

Open in new window

0
 
shobinsunCommented:
0
 
PeterdeBAuthor Commented:
Exactly what I asked for thanks a lot! Some more questions will follow regarding this project.

Paul
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.