|
|
Posted by Mark D. Smith on 06/25/06 09:24
"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:8afe9$449d6d0f$8259c69c$13517@news2.tudelft.nl...
> Mark D. Smith wrote:
> > 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)
>
> What regex, what does it need to validate?
> Maybe:
> SELECT * FROM Jobs WHERE CONCAT(Job_Title, Job_Description, Job_Salary,
> Job_Location) REGEXP '$search'
> or
> SELECT * FROM Jobs WHERE Job_Title REGEXP '$search' OR Job_Description
> REGEXP '$search' OR Job_Salary REGEXP '$search' OR Job_Location REGEXP
> '$search'
>
> Depending on your exact needs. What are you trying to acconbmplish, what
> data is in the columns, what is in the regex?
>
> Grtz,
> --
> Rik Wasmus
>
>
I now have a new test the apply
CONCAT(Job_Title, Job_Description, Job_Salary1) REGEXP '$src') works but i
need to add a test for where
Job_Location ="$loc" ($loc is a number 1 to 19) currently
tried
WHERE CONCAT(Job_Title, Job_Description, Job_Salary1) REGEXP '$src') AND
Job_location ="$loc"
but no luck
Mark
Navigation:
[Reply to this message]
|