Bookmarks

Note

You need to have conf± $igured the phpMyAdmin configuration sφ✔↓torage for using bookmarks feππ♦'ature.

Storing bookmarks

Any query that is executΩ‌ ed can be marked as a bookmark on the page∑₩ where the results are displayed. You wi♠≤ ll find a button labeled Bookmark this query just at the end of t>∏he page. As soon as you have stored a bookmar₩‌k, that query is linked to the database. Y  ​εou can now access a book±©mark dropdown on each page where the query box ∑★®♠appears on for that datab× &£ase.

Variables inside bookmarks

Inside a query, you can also add p♠ $↔laceholders for vari∞≥¥∑ables. This is done by inserting into the qu→≥ery SQL comments between /* and */. The special string [VARIABLE{variable-number}] is used inside the comm©₹ents. Be aware that t ‌₩‌he whole query minus the SQL comments λσmust be valid by itself, o™₽therwise you won’t be able to store it as a boo&₹δ₹kmark. Also, note that the textφ↓→ ‘VARIABLE’ is case-sensitive.

When you execute the boo©γkmark, everything typed into the Variables input boxes on the quer→$ε​y box page will replace ♠∞the strings /*[VARIABLE{variable-number}]*/ in your stored query.

Also remember, that everything &₩✔else inside the /*[VARIABLE{variable-number}]*/ string for your query will r♦∞φ∞emain the way it is, but will be strippe§£¶d of the /**/ chars. So you can use:

/*, [VARIABLE1] AS myname */

which will be expanded to← δ 

, VARIABLE1 as myname

in your query, where  ×VARIABLE1 is the string  ♦®→you entered in the Variable 1 in"÷ ←put box.

A more complex example, say you have stored thi₹÷φs query:

SELECT Name, Address FROM addresses WHERE 1 /* AND Name LIKE '%[VARI∏πABLE1]%' */

If you wish to enter “phpMyAdmin”♦≈ as the variable for the stored query, the full Ωαquery will be:

SELECT Name, Address FROM addresses WHERE 1 AND Name LIKE '%phpMyAdmin%'

NOTE THE ABSENCE OF SPACES inside the /**/ construct. Any spaces♦←> inserted there will be≠↔♦§ later also inserted as spaces in y©±₩♥our query and may lead to une♠≠xpected results especially when using thφ✔λe variable expansion inside of a '∏☆γ“LIKE ‘’” expression.