dbChameleon by GEConsult  v27.5.12 GEC   SELECT * FROM 0test
 Current table 
Sort by   Desc   Asc
X

SEARCH FUNCTION HELP

Modifiers: ! (doesn't contain), >, <, =, >=, <= and ^ (is empty). Searches with any modifier apply to the entire field. Searches without modifiers look for any occurance of the search string within the selected field. After double-clicking the search button it reads Extend if a search can be extended with AND or OR in the operator field. The special ↑↓ operator inverts the current search.

Most searches can be saved for later use by entering a name in the "save as" field and clicking Save search. Any saved searches are available for the current table, are shown in a drop down list. Always click the Search button after selecting a saved search. A saved search cannot extend a current search.

The sndx button launches the Soundex utility which looks for a similar sounding word within a field. This is useful if a search term or target contains an apostrophe, hyphen or accented character or is a name with possible spelling variations. More detail on soundex comparisons is provided in the utility.

Block operations apply to all records returned by the current search filter. Block operations cannot be undone. Backing up is recommended before trying any block operation.
  Find      
Pg 1 of 9Rows/pg    1 ...
Utilities



*id
int:11id
1
texttext0
Sample text
date:10date0
2016-01-08
decimal:14decimal0
11.08
int:20integer0
122
string:21phone
555-555-1234
string:90web http://web.ncf.ca/aa353/
string:51email Click to email
timestamp:19timestamp
2021-05-25 09:00:14
 



*id
int:11id
2
texttext0
Second sample
date:10date0
2016-10-31
decimal:14decimal0
3.74
int:20integer0
4
string:21phone
1
string:90web http://EndOfTheInter.net
string:51email Click to email
timestamp:19timestamp
2021-05-18 14:35:36
 
Pg 1 of 9      1 ...  (18 rec)












id 
dbChameleon  v27.5.12  (© Gary Eikenberry 2009-2021) GEConsult generic MySQL database management system
This app requires JavaScript and non-persistent cookies which are cleared when the Exit button is clicked. As some functions and utilities run in a separate window it is recommended that popup blocking be disabled for this site.