content_image/718216.jpg content_image/718224.jpg
Example: HELP ’replace’ 

Yields: 

name: REPLACE description: Syntax: REPLACE(str,from_str,to_str) Returns the string str with all occurrences of the string from_str replaced by the string to_str. REPLACE() performs a case-sensitive match when searching for from_str. example: mysql> SELECT REPLACE(’www.mysql.com’, ’w’, ’Ww’); -> ’WwWwWw.mysql.com’ 

•Result set containing multiple rows with two columns 

This means that the search string matched many help topics. The result set indicates the help topic names: 

• name : The help topic name. 

• is_it_category : Y  if the name represents a help category, N  if it does not. If it does not, the name value when specified as the argument to the HELP  statement should yield a single-row result set containing a description for the named item. 

Example: HELP ’status’ 

Yields: 

<img src='content_image/718216.jpg'>

•Result set containing multiple rows with three columns 

This means the search string matches a category. The result set contains category entries: 

• source_category_name : The help category name. 

• name : The category or topic name 

• is_it_category : Y  if the name represents a help category, N  if it does not. If it does not, the name value when specified as the argument to the HELP  statement should yield a single-row result set containing a description for the named item. 

Example: HELP ’functions’ 

Yields: 

<img src='content_image/718224.jpg'>

