Using Mysql function add asterisk (*) in front of the string.
Example Output:
********MyTestString
*******MyTestString2
**********TestString
lpad, one of the functions from MySQL which able do that
Sample Data:
| Id | Name | Date |
| 1 | MyTestString | 2013-01-1 |
| 2 | MyTestString2 | 2013-01-5 |
| 3 | TestString | 2013-01-5 |
Using Syntax below you able get the result like above example
Syntax:
LPAD(str, len, padstr)Example:
SELECT LPAD(Name, 20, '*') as name FROM TABLEOutput:
name --------------------- ********MyTestString *******MyTestString2 **********TestString