Posted by bobzimuta on 10/12/23 11:39

SELECT IF( CHAR_LENGTH( `text_column` ) > 0, 1, 0 ) AS fulltext_exists
FROM table WHERE .....

will return fulltext_exists as 1 if `text_column` has a length greater
than 0. Otherwise returns 0


Want to get just the first 50 characters from the fulltext as the
summary or intro?

SELECT LEFT( `text_column`, 50 ) AS summary FROM table WHERE ....

• Next in forum: Re: Return bool from query
• Prev in forum: Re: Validate IPv6 Address
• Thread view: Re: Return bool from query

[Reply to this message]