Select Text Snippets

18 January, 2011   

Auto Select Textarea Text

13 June, 2016   

As a "preview" of text, this MySQL select will return the first few words out of a text field in a database. It returns entire words (doesn't cut them off in the middle) and follows the last word with an elipse "..."

MySQL code example showing how to SELECT within a SELECT (a subselect).

Sometimes you have some information on your page and your visitors might want to copy it. The easiest way is to provide a mechanism that allows them to simply click a button to do so. You have to paste this code into the head of your web page:

16 January, 2012   

MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier with MATCH function

29 December, 2011   

ASP code example to redirect the user to a different URL.

30 November, 2014   

Mysql code example for Regular Expression SELECT statement

09 May, 2011   

This is a general code to use when selecting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match. This MYSQL Code using in PHP

09 July, 2013   

Copy selected text by allowing user to simply click a button

24 December, 2012   

jQuery plugin code to image selection

19 September, 2013   

Function to test for the existence of at least 1 matching row, without having to count them all!

MySQL MATCH() function performs a natural language search for a string against a text

04 January, 2012   

SQL example Code for SELECT statement with HAVING clause

08 February, 2011   

Example Form Markup

Mysql code example to SELECT based on a field that can have a NULL value.

26 February, 2015   

Simple and easy mySQL code to select the row number

Returns the text between the specified delimiters in MySQL.

Returns the text between the specified delimiters in MySQL.

09 October, 2011   

Example shows how to get the database date and time.

20 June, 2013   

How to select between two dates using MySQL code