Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 679
  • Last Modified:

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

0
shopjd
Asked:
shopjd
1 Solution
 
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
 
Roger BaklundCommented:
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
 
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now