Posted by Mark D. Smith on 06/24/06 16:44

Hi

i want to only do a REGEXP against 4 columns in a table

Job_Title | Job_Description | Job_Salary | Job_Location

i tried $sql = "SELECT * FROM Jobs WHERE (Job_Title, Job_Description,
Job_Salary, Job_Location) REGEXP '$search'"

but its not a valid SQL statement. also tried with WHERE (Job_Title OR
Job_Description OR Job_Salary OR Job_Location)

same problem

mysql is 3.23.56 & php4.3.11

i have googled but not found a solution.

Mark

• Next in forum: Re: search only certain columns in 1 table using php
• Prev in forum: Re: Learning php Sql
• Thread view: search only certain columns in 1 table using php

[Reply to this message]