mysql EXPLAIN SELECT * FROM tbl_name WHERE FALSE\G

EXPLAIN SELECT * FROM tbl_name WHERE FALSE\G
how can this be typed in sqlyog
\ is ignored as a character

shopjdAsked:
Who is Participating?
 
Roger BaklundConnect With a Mentor Commented:
The \G only works in the mysql client, it shows the results vertically:

http://dev.mysql.com/doc/refman/5.1/en/mysql-tips.html
0
 
cevomanCommented:
Hi there,

You need to select a column your trying to search a value, so for example if the column was `field1` and you wanted to search for the text "FALSE\G" your SQL query would be as attached

Kind regards
James


SELECT * FROM tbl_name WHERE `field1` = "FALSE\G"

Open in new window

0
 
Tony McCreathTechnical SEO ConsultantCommented:
The /G command is  not part of the query, but after it.

Your query does not show much, as a WHERE FALSE will return nothing.

Could you provide more info.
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.