mySQL 4.1.3-beta subqueries(correction on table names)

2004-11-11 Thread L a n a
Hello, Since I had a problem with except operator and subqueries, I investigated a topic on mysql version capability. I tried a few examples which were offered on this mailing list, all of them gave me a syntax error, so I've read a manual and tried some examples from it. However, things that m

mySQL 4.1.3-beta subqueries

2004-11-11 Thread L a n a
Hello, Since I had a problem with except operator and subqueries, I investigated a topic on mysql version capability. I tried a few examples which were offered on this mailing list, all of them gave me a syntax error, so I've read a manual and tried some examples from it. However, things that m

union, intersct and except operation?

2004-11-09 Thread L a n a
Hello, I've had a problem trying to get working except operator in mysql: statement "SELECT study from table WHERE keyword = 'chemistry' NOT keyword = 'computers'" returns SQL error I've got the following not working solutions to my problem: SELECT [distinct] study FROM table WHERE keyword = 'ch

how to use except operation (corrections for the return results)?

2004-11-08 Thread L a n a
Hello, I've had a problem: statement "SELECT data_id from table WHERE keyword = a NOT keyword = b" returns SQL error I've got the following not working solutions to my problem: SELECT data_id FROM table WHERE keyword = a AND keyword <>(or !=) b SELECT data_id FROM table WHERE keyword = a AND NOT

how to use except operation?

2004-11-08 Thread L a n a
Hello, I've had a problem: statement "SELECT data_id from table WHERE keyword = a NOT keyword =b" returns SQL error I've got the following not working solutions to my problem: SELECT data_id FROM table WHERE keyword = a AND keyword <>(or !=) b SELECT data_id FROM table WHERE keyword = a AND NOT (

mysql NOT operator

2004-11-06 Thread L a n a
Hello, Could you please tell me how I can write an sql statement in php when I'd llike to select boolean search in one field like "except" or "NOT" result. What I mean here is that I can execute the following: 1. SELECT data_id from table WHERE keyword = a AND keyword =b 2. SELECT data_id from ta

how to intersect resulting sets form sql query

2004-07-18 Thread L a n a
Hello, I'm trying to find a resulting set for searching two keywords, like: Select * from table where filed_a like '%keyword1%' OR field_b like '%keyword1%' INTERSECT (Select * from table where filed_a like '%keyword2%' OR field_b like '%keyword2%'). This statement gives an error in syntax. What

deleting duplicates from table

2004-07-16 Thread L a n a
Hello, I'm trying to solve a task in Mysql 4: I have a table rec_id | record_ref | keyword ** 1| 2| apple 2| 2|orange 3| 2|apple 4| 3|mango ** How can I delete

deleting duplicates from table

2004-07-16 Thread L a n a
Hello, I'm trying to solve a task in Mysql 4: I have a table rec_id | record_ref | keyword ** 1| 2| apple 2| 2|orange 3| 2|apple 4| 3|mango ** How can I delete

return substrings out of a string

2004-06-30 Thread L a n a
Hello, I’m working on a search function using PHP4 and MYSQL4. I’m looking for a function that allow to take a string value (consisted of several substrings separated by coma) out of db field and return each substring one by one. Could you please tell me if there is a function that can do somet