Mysql Query Prob

[umerkk]

Hi I want a mysql querry which show me result like

Select * from Bb Where Pd = '104' AND MsgFrom = '[e-mail]' AND TO = '[e-mail]'

When i add AND two times in query it show me erro, Anyone can help me out that how can i check that on BB where Pd is 104 and msgfrom is [e-mail] and to field is equal to [e-mail]

Thanks in Advance

[edited by: eelixduppy at 1:42 pm (utc) on June 24, 2007]
[edit reason] example.com [/edit]

[Frank_Rizzo]

AND TO = '[e-mail]'

the TO seems to be your problem.

Shouldn't it be something like

AND MsgTo

[edited by: eelixduppy at 1:43 pm (utc) on June 24, 2007]
[edit reason] example.com [/edit]

[henry0]

"TO" is causing your query to fail
"TO" is a "reserved" word
you are not allowed to use it, and you need to rename it.

[Gian04]

Select * from Bb Where Pd = '104' AND MsgFrom = '[e-mail]' AND `TO` = '[e-mail]'

[edited by: eelixduppy at 1:43 pm (utc) on June 24, 2007]
[edit reason] example.com [/edit]

[eelixduppy]

TO is indeed a reserved word [dev.mysql.com]. You can still use it, as shown above, by escaping it with the prime character(`), however, it is best to avoid using reserved words as column names as much as possible, so changing won't hurt, unless it will cause a lot of work for you. Just keep it in mind in the future :)

[umerkk]

Ok i solved it out, But What if i want to execute 2 kind of query at a time like

Select * from PD = '[e-mail]' WHERE parentbd = '104' and msgfrom = '[e-mail]' and msgto = '[e-mail]'

Or and also Reversily like

Select * from PD = '[e-mail]' WHERE parentbd = '104' and msgfrom = '[e-mail]' and msgto = '[e-mail]'

[eelixduppy]

Neither of those queries are valid. Are you trying to update the row? In you want to update multiple rows at the same time, you can use the IN function [dev.mysql.com] with a correctly formated UPDATE query [dev.mysql.com].

[henry0]

eelix I cannot find where we have that "tutorial" thread with most of the MySQL query, insert, update etc...

would you point ummerk to that post

I think he looks for ¦¦ or OR
(Forum breaks pipes)

[eelixduppy]

>> would you point ummerk to that post

You mean this one?: [webmasterworld.com...] :)