Solved

mysql EXPLAIN SELECT * FROM tbl_name WHERE FALSE\G

Posted on 2009-05-14
3
651 Views
Last Modified: 2013-12-12
EXPLAIN SELECT * FROM tbl_name WHERE FALSE\G
how can this be typed in sqlyog
\ is ignored as a character

0
Comment
Question by:shopjd
3 Comments
 
LVL 3

Expert Comment

by:cevoman
ID: 24387535
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
 
LVL 39

Accepted Solution

by:
Roger Baklund earned 500 total points
ID: 24388042
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
 
LVL 23

Expert Comment

by:Tiggerito
ID: 24395815
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now