{"id":252,"date":"2021-03-23T13:11:50","date_gmt":"2021-03-23T13:11:50","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/?page_id=252"},"modified":"2021-03-25T13:48:05","modified_gmt":"2021-03-25T13:48:05","slug":"filtering-records","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/national-4\/filtering-records\/","title":{"rendered":"Filtering Records"},"content":{"rendered":"<p>Instead of manually looking through all records, <em>filters<\/em> can be created to only display records that match conditions.<\/p>\n<ul>\n<li>Click on the &#8220;Browse Data&#8221; tab, and select the table to edit:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-353\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091510\/DB4SQL-browse-table.png\" alt=\"\" width=\"522\" height=\"62\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091510\/DB4SQL-browse-table.png 522w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091510\/DB4SQL-browse-table-300x36.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEOv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQC%2Fl9xeM%2Ffay%2BfL6bv%2BR2qOl22RLpgvbzOXt%2F47YSTZKwIhAJ7nN%2FD8dQ4sQowOietmOGstlZ%2FVb1Nx9asPJe9c5TQbKsEFCLT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgzFepxoCffCWsvfQ5cqlQXV6H8pqRxR%2F8FBTNoE07wvSQ2WBB8zMdtSds%2B%2BuS%2BALcgPxD16USq659qOEW8KxdBnwOsnR264Mjkpdm4XMjyALKCd%2FeHGzRCyMxz7BVLXVMlTm4d6Ckppq3EO2kQB4K8oqb8QkbU9gK6LTKl1%2BrSQxVxOG4Org6xlOcGZs0hEJfTyZLF3L%2B1KQDQn9dWzMu6pev4nZsat2WtegVhbOWqjEWiLiKyGKFhQYkJs8h1PkERSfUJfXFWk%2BdoZ5yA8H9lEesEyeUg1LaRAsYESASb4ZKPvkcEL8OA%2Bsa4Qy63BEx%2BU2KUmj9NF7vR%2BjU8g06VW%2Bb5gGLoZHZr%2BJw9hBp5XqCV3I7wQse1K3iltXO58gFPqqYiyFrku6kr6GZ8tuqpPPmgQ%2BVotPZqlxYHbTZOQ%2FmldzhoI367fdohNkrwOx3IfSAQE7EdaLY3Ln%2B2PP9YYOr5f0Djgl1Lp7LLfZEcHlbblpVp%2FbqcURjxbt86x8GW%2B1nZhprTI1S2qr19XcOL8Rjjurz%2BYdcWVe0SNVGl8YWc0oOyPxokTxkgnrOXaHrhrLAa9IVscL%2Frj0cOITHZTwhNcx%2FYKFvM4K5TrTJ57RICzJ2QSttWx5jP9qtgMRi5JP0oi2qTgpBFyH3U27GY9YewCYWX8JJveLVCVyTYjScqvQ4Ua7cPD2Iw4TI18SZBX8nm5mcEX2y0hlyM5zpCcx0nz4mzvOltyTZZvbQK5G9jV%2FLjL5bmp8t9pf213ltdIyRKML5K3M1kitkv91gnFViieIH5ecqdUI8j7ya9yfxE9TroWEooVNZnmitqO2N1BF%2Fj1tkkw8znx9%2BRyxLj8gSf%2BHtAdQ8NlKszR%2BUeL3D17PnUIVdAVa5gRVE4FqlKWpnExMIywuc8GOrABdUxI7yp2hbH6F%2FromTe5Aj7qD0a0GebBgpOKu8z5WSaLMSkAOaLYEh%2BMgBQj2OJtSCt%2B1TkQpLx1yPPDhSF%2FoyGP29C0TXe%2Fs7EkP8MCwijki02ZqWh245T4oFePkv1311rpdwqMdvdQaA43sPhdv63SivCj2MhHzo7KBeTUwfOsulhSTqoWTbhkbZsej3IZ%2Bp56aov2pmM8RK898F3nnClVVYH%2FsynSHZ0xzb0e7Bs%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZ5D4I2SS%2F20260426%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260426T184802Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=76207cc83617d58d8f52963a416b05db3b7c75a292462cac65e901c7943f76bc 300w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>At the top of each column are empty filters &#8211; typing into these will restrict which records are displayed:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-366\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25093213\/DB4SQL-filters-1.png\" alt=\"\" width=\"742\" height=\"108\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25093213\/DB4SQL-filters-1.png 742w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25093213\/DB4SQL-filters-1-300x44.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEOv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQC%2Fl9xeM%2Ffay%2BfL6bv%2BR2qOl22RLpgvbzOXt%2F47YSTZKwIhAJ7nN%2FD8dQ4sQowOietmOGstlZ%2FVb1Nx9asPJe9c5TQbKsEFCLT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgzFepxoCffCWsvfQ5cqlQXV6H8pqRxR%2F8FBTNoE07wvSQ2WBB8zMdtSds%2B%2BuS%2BALcgPxD16USq659qOEW8KxdBnwOsnR264Mjkpdm4XMjyALKCd%2FeHGzRCyMxz7BVLXVMlTm4d6Ckppq3EO2kQB4K8oqb8QkbU9gK6LTKl1%2BrSQxVxOG4Org6xlOcGZs0hEJfTyZLF3L%2B1KQDQn9dWzMu6pev4nZsat2WtegVhbOWqjEWiLiKyGKFhQYkJs8h1PkERSfUJfXFWk%2BdoZ5yA8H9lEesEyeUg1LaRAsYESASb4ZKPvkcEL8OA%2Bsa4Qy63BEx%2BU2KUmj9NF7vR%2BjU8g06VW%2Bb5gGLoZHZr%2BJw9hBp5XqCV3I7wQse1K3iltXO58gFPqqYiyFrku6kr6GZ8tuqpPPmgQ%2BVotPZqlxYHbTZOQ%2FmldzhoI367fdohNkrwOx3IfSAQE7EdaLY3Ln%2B2PP9YYOr5f0Djgl1Lp7LLfZEcHlbblpVp%2FbqcURjxbt86x8GW%2B1nZhprTI1S2qr19XcOL8Rjjurz%2BYdcWVe0SNVGl8YWc0oOyPxokTxkgnrOXaHrhrLAa9IVscL%2Frj0cOITHZTwhNcx%2FYKFvM4K5TrTJ57RICzJ2QSttWx5jP9qtgMRi5JP0oi2qTgpBFyH3U27GY9YewCYWX8JJveLVCVyTYjScqvQ4Ua7cPD2Iw4TI18SZBX8nm5mcEX2y0hlyM5zpCcx0nz4mzvOltyTZZvbQK5G9jV%2FLjL5bmp8t9pf213ltdIyRKML5K3M1kitkv91gnFViieIH5ecqdUI8j7ya9yfxE9TroWEooVNZnmitqO2N1BF%2Fj1tkkw8znx9%2BRyxLj8gSf%2BHtAdQ8NlKszR%2BUeL3D17PnUIVdAVa5gRVE4FqlKWpnExMIywuc8GOrABdUxI7yp2hbH6F%2FromTe5Aj7qD0a0GebBgpOKu8z5WSaLMSkAOaLYEh%2BMgBQj2OJtSCt%2B1TkQpLx1yPPDhSF%2FoyGP29C0TXe%2Fs7EkP8MCwijki02ZqWh245T4oFePkv1311rpdwqMdvdQaA43sPhdv63SivCj2MhHzo7KBeTUwfOsulhSTqoWTbhkbZsej3IZ%2Bp56aov2pmM8RK898F3nnClVVYH%2FsynSHZ0xzb0e7Bs%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZ5D4I2SS%2F20260426%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260426T184802Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=cd4c2cb9dc8d28abcfa8e95d398d10c3d08546d9eeed9c4ea4c4c921af54b8a7 300w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/li>\n<\/ul>\n<hr \/>\n<h1>Simple Text Filters<\/h1>\n<ul>\n<li>Typing in text (letters or numbers) will only show the records that contain that text anywhere in the field.<br \/>\nCapitalisation of letters is ignored:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-368\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25094039\/DB4SQL-filters-2.png\" alt=\"\" width=\"229\" height=\"160\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-367\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25094038\/DB4SQL-filters-3.png\" alt=\"\" width=\"160\" height=\"106\" \/><\/li>\n<\/ul>\n<hr \/>\n<h1>Exact Matches<\/h1>\n<ul>\n<li>Simple text searches may select records too many records:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-370\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25131613\/DB4SQL-filters-4.png\" alt=\"\" width=\"383\" height=\"108\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25131613\/DB4SQL-filters-4.png 383w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25131613\/DB4SQL-filters-4-300x85.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEOv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQC%2Fl9xeM%2Ffay%2BfL6bv%2BR2qOl22RLpgvbzOXt%2F47YSTZKwIhAJ7nN%2FD8dQ4sQowOietmOGstlZ%2FVb1Nx9asPJe9c5TQbKsEFCLT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgzFepxoCffCWsvfQ5cqlQXV6H8pqRxR%2F8FBTNoE07wvSQ2WBB8zMdtSds%2B%2BuS%2BALcgPxD16USq659qOEW8KxdBnwOsnR264Mjkpdm4XMjyALKCd%2FeHGzRCyMxz7BVLXVMlTm4d6Ckppq3EO2kQB4K8oqb8QkbU9gK6LTKl1%2BrSQxVxOG4Org6xlOcGZs0hEJfTyZLF3L%2B1KQDQn9dWzMu6pev4nZsat2WtegVhbOWqjEWiLiKyGKFhQYkJs8h1PkERSfUJfXFWk%2BdoZ5yA8H9lEesEyeUg1LaRAsYESASb4ZKPvkcEL8OA%2Bsa4Qy63BEx%2BU2KUmj9NF7vR%2BjU8g06VW%2Bb5gGLoZHZr%2BJw9hBp5XqCV3I7wQse1K3iltXO58gFPqqYiyFrku6kr6GZ8tuqpPPmgQ%2BVotPZqlxYHbTZOQ%2FmldzhoI367fdohNkrwOx3IfSAQE7EdaLY3Ln%2B2PP9YYOr5f0Djgl1Lp7LLfZEcHlbblpVp%2FbqcURjxbt86x8GW%2B1nZhprTI1S2qr19XcOL8Rjjurz%2BYdcWVe0SNVGl8YWc0oOyPxokTxkgnrOXaHrhrLAa9IVscL%2Frj0cOITHZTwhNcx%2FYKFvM4K5TrTJ57RICzJ2QSttWx5jP9qtgMRi5JP0oi2qTgpBFyH3U27GY9YewCYWX8JJveLVCVyTYjScqvQ4Ua7cPD2Iw4TI18SZBX8nm5mcEX2y0hlyM5zpCcx0nz4mzvOltyTZZvbQK5G9jV%2FLjL5bmp8t9pf213ltdIyRKML5K3M1kitkv91gnFViieIH5ecqdUI8j7ya9yfxE9TroWEooVNZnmitqO2N1BF%2Fj1tkkw8znx9%2BRyxLj8gSf%2BHtAdQ8NlKszR%2BUeL3D17PnUIVdAVa5gRVE4FqlKWpnExMIywuc8GOrABdUxI7yp2hbH6F%2FromTe5Aj7qD0a0GebBgpOKu8z5WSaLMSkAOaLYEh%2BMgBQj2OJtSCt%2B1TkQpLx1yPPDhSF%2FoyGP29C0TXe%2Fs7EkP8MCwijki02ZqWh245T4oFePkv1311rpdwqMdvdQaA43sPhdv63SivCj2MhHzo7KBeTUwfOsulhSTqoWTbhkbZsej3IZ%2Bp56aov2pmM8RK898F3nnClVVYH%2FsynSHZ0xzb0e7Bs%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZ5D4I2SS%2F20260426%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260426T184802Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8cadb9dab5942ba23d0d34d278a667871dd7ed87474927024b7b7f2498e26bc8 300w\" sizes=\"auto, (max-width: 383px) 100vw, 383px\" \/><\/li>\n<li>An exact match can be used by using an equals sign.<br \/>\n<em>Do not use quotation marks, or a space after the sign.<\/em><br \/>\n<em>Capitalisation of letters must be exact.<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-371\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25131614\/DB4SQL-filters-5.png\" alt=\"\" width=\"388\" height=\"87\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25131614\/DB4SQL-filters-5.png 388w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25131614\/DB4SQL-filters-5-300x67.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEOv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQC%2Fl9xeM%2Ffay%2BfL6bv%2BR2qOl22RLpgvbzOXt%2F47YSTZKwIhAJ7nN%2FD8dQ4sQowOietmOGstlZ%2FVb1Nx9asPJe9c5TQbKsEFCLT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgzFepxoCffCWsvfQ5cqlQXV6H8pqRxR%2F8FBTNoE07wvSQ2WBB8zMdtSds%2B%2BuS%2BALcgPxD16USq659qOEW8KxdBnwOsnR264Mjkpdm4XMjyALKCd%2FeHGzRCyMxz7BVLXVMlTm4d6Ckppq3EO2kQB4K8oqb8QkbU9gK6LTKl1%2BrSQxVxOG4Org6xlOcGZs0hEJfTyZLF3L%2B1KQDQn9dWzMu6pev4nZsat2WtegVhbOWqjEWiLiKyGKFhQYkJs8h1PkERSfUJfXFWk%2BdoZ5yA8H9lEesEyeUg1LaRAsYESASb4ZKPvkcEL8OA%2Bsa4Qy63BEx%2BU2KUmj9NF7vR%2BjU8g06VW%2Bb5gGLoZHZr%2BJw9hBp5XqCV3I7wQse1K3iltXO58gFPqqYiyFrku6kr6GZ8tuqpPPmgQ%2BVotPZqlxYHbTZOQ%2FmldzhoI367fdohNkrwOx3IfSAQE7EdaLY3Ln%2B2PP9YYOr5f0Djgl1Lp7LLfZEcHlbblpVp%2FbqcURjxbt86x8GW%2B1nZhprTI1S2qr19XcOL8Rjjurz%2BYdcWVe0SNVGl8YWc0oOyPxokTxkgnrOXaHrhrLAa9IVscL%2Frj0cOITHZTwhNcx%2FYKFvM4K5TrTJ57RICzJ2QSttWx5jP9qtgMRi5JP0oi2qTgpBFyH3U27GY9YewCYWX8JJveLVCVyTYjScqvQ4Ua7cPD2Iw4TI18SZBX8nm5mcEX2y0hlyM5zpCcx0nz4mzvOltyTZZvbQK5G9jV%2FLjL5bmp8t9pf213ltdIyRKML5K3M1kitkv91gnFViieIH5ecqdUI8j7ya9yfxE9TroWEooVNZnmitqO2N1BF%2Fj1tkkw8znx9%2BRyxLj8gSf%2BHtAdQ8NlKszR%2BUeL3D17PnUIVdAVa5gRVE4FqlKWpnExMIywuc8GOrABdUxI7yp2hbH6F%2FromTe5Aj7qD0a0GebBgpOKu8z5WSaLMSkAOaLYEh%2BMgBQj2OJtSCt%2B1TkQpLx1yPPDhSF%2FoyGP29C0TXe%2Fs7EkP8MCwijki02ZqWh245T4oFePkv1311rpdwqMdvdQaA43sPhdv63SivCj2MhHzo7KBeTUwfOsulhSTqoWTbhkbZsej3IZ%2Bp56aov2pmM8RK898F3nnClVVYH%2FsynSHZ0xzb0e7Bs%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZ5D4I2SS%2F20260426%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260426T184802Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=01f2ea64515f772b4c124be285443ba7d83f9ba973fe6624e0c6c66d7b8fabcf 300w\" sizes=\"auto, (max-width: 388px) 100vw, 388px\" \/><\/li>\n<\/ul>\n<hr \/>\n<h1>Comparisons<\/h1>\n<p>Less than (&lt;) and greater than (&gt;) signs can be used to find numbers, date or times that are under or over a value.<\/p>\n<h2>Less Than &lt;<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-377\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133436\/DB4SQL-filters-6a.png\" alt=\"\" width=\"389\" height=\"159\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133436\/DB4SQL-filters-6a.png 389w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133436\/DB4SQL-filters-6a-300x123.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEOv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQC%2Fl9xeM%2Ffay%2BfL6bv%2BR2qOl22RLpgvbzOXt%2F47YSTZKwIhAJ7nN%2FD8dQ4sQowOietmOGstlZ%2FVb1Nx9asPJe9c5TQbKsEFCLT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgzFepxoCffCWsvfQ5cqlQXV6H8pqRxR%2F8FBTNoE07wvSQ2WBB8zMdtSds%2B%2BuS%2BALcgPxD16USq659qOEW8KxdBnwOsnR264Mjkpdm4XMjyALKCd%2FeHGzRCyMxz7BVLXVMlTm4d6Ckppq3EO2kQB4K8oqb8QkbU9gK6LTKl1%2BrSQxVxOG4Org6xlOcGZs0hEJfTyZLF3L%2B1KQDQn9dWzMu6pev4nZsat2WtegVhbOWqjEWiLiKyGKFhQYkJs8h1PkERSfUJfXFWk%2BdoZ5yA8H9lEesEyeUg1LaRAsYESASb4ZKPvkcEL8OA%2Bsa4Qy63BEx%2BU2KUmj9NF7vR%2BjU8g06VW%2Bb5gGLoZHZr%2BJw9hBp5XqCV3I7wQse1K3iltXO58gFPqqYiyFrku6kr6GZ8tuqpPPmgQ%2BVotPZqlxYHbTZOQ%2FmldzhoI367fdohNkrwOx3IfSAQE7EdaLY3Ln%2B2PP9YYOr5f0Djgl1Lp7LLfZEcHlbblpVp%2FbqcURjxbt86x8GW%2B1nZhprTI1S2qr19XcOL8Rjjurz%2BYdcWVe0SNVGl8YWc0oOyPxokTxkgnrOXaHrhrLAa9IVscL%2Frj0cOITHZTwhNcx%2FYKFvM4K5TrTJ57RICzJ2QSttWx5jP9qtgMRi5JP0oi2qTgpBFyH3U27GY9YewCYWX8JJveLVCVyTYjScqvQ4Ua7cPD2Iw4TI18SZBX8nm5mcEX2y0hlyM5zpCcx0nz4mzvOltyTZZvbQK5G9jV%2FLjL5bmp8t9pf213ltdIyRKML5K3M1kitkv91gnFViieIH5ecqdUI8j7ya9yfxE9TroWEooVNZnmitqO2N1BF%2Fj1tkkw8znx9%2BRyxLj8gSf%2BHtAdQ8NlKszR%2BUeL3D17PnUIVdAVa5gRVE4FqlKWpnExMIywuc8GOrABdUxI7yp2hbH6F%2FromTe5Aj7qD0a0GebBgpOKu8z5WSaLMSkAOaLYEh%2BMgBQj2OJtSCt%2B1TkQpLx1yPPDhSF%2FoyGP29C0TXe%2Fs7EkP8MCwijki02ZqWh245T4oFePkv1311rpdwqMdvdQaA43sPhdv63SivCj2MhHzo7KBeTUwfOsulhSTqoWTbhkbZsej3IZ%2Bp56aov2pmM8RK898F3nnClVVYH%2FsynSHZ0xzb0e7Bs%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZ5D4I2SS%2F20260426%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260426T184802Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=d6ff83bccb3b964649b3e976b42fddd7dfd476f8988f829c4ddd5d224cc32df4 300w\" sizes=\"auto, (max-width: 389px) 100vw, 389px\" \/><\/p>\n<h1>Less Than or Equal To &lt;=<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-378\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133438\/DB4SQL-filters-6b.png\" alt=\"\" width=\"392\" height=\"185\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133438\/DB4SQL-filters-6b.png 392w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133438\/DB4SQL-filters-6b-300x142.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEOv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQC%2Fl9xeM%2Ffay%2BfL6bv%2BR2qOl22RLpgvbzOXt%2F47YSTZKwIhAJ7nN%2FD8dQ4sQowOietmOGstlZ%2FVb1Nx9asPJe9c5TQbKsEFCLT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgzFepxoCffCWsvfQ5cqlQXV6H8pqRxR%2F8FBTNoE07wvSQ2WBB8zMdtSds%2B%2BuS%2BALcgPxD16USq659qOEW8KxdBnwOsnR264Mjkpdm4XMjyALKCd%2FeHGzRCyMxz7BVLXVMlTm4d6Ckppq3EO2kQB4K8oqb8QkbU9gK6LTKl1%2BrSQxVxOG4Org6xlOcGZs0hEJfTyZLF3L%2B1KQDQn9dWzMu6pev4nZsat2WtegVhbOWqjEWiLiKyGKFhQYkJs8h1PkERSfUJfXFWk%2BdoZ5yA8H9lEesEyeUg1LaRAsYESASb4ZKPvkcEL8OA%2Bsa4Qy63BEx%2BU2KUmj9NF7vR%2BjU8g06VW%2Bb5gGLoZHZr%2BJw9hBp5XqCV3I7wQse1K3iltXO58gFPqqYiyFrku6kr6GZ8tuqpPPmgQ%2BVotPZqlxYHbTZOQ%2FmldzhoI367fdohNkrwOx3IfSAQE7EdaLY3Ln%2B2PP9YYOr5f0Djgl1Lp7LLfZEcHlbblpVp%2FbqcURjxbt86x8GW%2B1nZhprTI1S2qr19XcOL8Rjjurz%2BYdcWVe0SNVGl8YWc0oOyPxokTxkgnrOXaHrhrLAa9IVscL%2Frj0cOITHZTwhNcx%2FYKFvM4K5TrTJ57RICzJ2QSttWx5jP9qtgMRi5JP0oi2qTgpBFyH3U27GY9YewCYWX8JJveLVCVyTYjScqvQ4Ua7cPD2Iw4TI18SZBX8nm5mcEX2y0hlyM5zpCcx0nz4mzvOltyTZZvbQK5G9jV%2FLjL5bmp8t9pf213ltdIyRKML5K3M1kitkv91gnFViieIH5ecqdUI8j7ya9yfxE9TroWEooVNZnmitqO2N1BF%2Fj1tkkw8znx9%2BRyxLj8gSf%2BHtAdQ8NlKszR%2BUeL3D17PnUIVdAVa5gRVE4FqlKWpnExMIywuc8GOrABdUxI7yp2hbH6F%2FromTe5Aj7qD0a0GebBgpOKu8z5WSaLMSkAOaLYEh%2BMgBQj2OJtSCt%2B1TkQpLx1yPPDhSF%2FoyGP29C0TXe%2Fs7EkP8MCwijki02ZqWh245T4oFePkv1311rpdwqMdvdQaA43sPhdv63SivCj2MhHzo7KBeTUwfOsulhSTqoWTbhkbZsej3IZ%2Bp56aov2pmM8RK898F3nnClVVYH%2FsynSHZ0xzb0e7Bs%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZ5D4I2SS%2F20260426%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260426T184802Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=98aa75f1b135d5c9e8bed3ab0f9c43c57a47d0eadeb50760241de0ea89ee1c3e 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/p>\n<h1>Greater Than &gt;<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-375\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133433\/DB4SQL-filters-7a.png\" alt=\"\" width=\"390\" height=\"183\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133433\/DB4SQL-filters-7a.png 390w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133433\/DB4SQL-filters-7a-300x141.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEOv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQC%2Fl9xeM%2Ffay%2BfL6bv%2BR2qOl22RLpgvbzOXt%2F47YSTZKwIhAJ7nN%2FD8dQ4sQowOietmOGstlZ%2FVb1Nx9asPJe9c5TQbKsEFCLT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgzFepxoCffCWsvfQ5cqlQXV6H8pqRxR%2F8FBTNoE07wvSQ2WBB8zMdtSds%2B%2BuS%2BALcgPxD16USq659qOEW8KxdBnwOsnR264Mjkpdm4XMjyALKCd%2FeHGzRCyMxz7BVLXVMlTm4d6Ckppq3EO2kQB4K8oqb8QkbU9gK6LTKl1%2BrSQxVxOG4Org6xlOcGZs0hEJfTyZLF3L%2B1KQDQn9dWzMu6pev4nZsat2WtegVhbOWqjEWiLiKyGKFhQYkJs8h1PkERSfUJfXFWk%2BdoZ5yA8H9lEesEyeUg1LaRAsYESASb4ZKPvkcEL8OA%2Bsa4Qy63BEx%2BU2KUmj9NF7vR%2BjU8g06VW%2Bb5gGLoZHZr%2BJw9hBp5XqCV3I7wQse1K3iltXO58gFPqqYiyFrku6kr6GZ8tuqpPPmgQ%2BVotPZqlxYHbTZOQ%2FmldzhoI367fdohNkrwOx3IfSAQE7EdaLY3Ln%2B2PP9YYOr5f0Djgl1Lp7LLfZEcHlbblpVp%2FbqcURjxbt86x8GW%2B1nZhprTI1S2qr19XcOL8Rjjurz%2BYdcWVe0SNVGl8YWc0oOyPxokTxkgnrOXaHrhrLAa9IVscL%2Frj0cOITHZTwhNcx%2FYKFvM4K5TrTJ57RICzJ2QSttWx5jP9qtgMRi5JP0oi2qTgpBFyH3U27GY9YewCYWX8JJveLVCVyTYjScqvQ4Ua7cPD2Iw4TI18SZBX8nm5mcEX2y0hlyM5zpCcx0nz4mzvOltyTZZvbQK5G9jV%2FLjL5bmp8t9pf213ltdIyRKML5K3M1kitkv91gnFViieIH5ecqdUI8j7ya9yfxE9TroWEooVNZnmitqO2N1BF%2Fj1tkkw8znx9%2BRyxLj8gSf%2BHtAdQ8NlKszR%2BUeL3D17PnUIVdAVa5gRVE4FqlKWpnExMIywuc8GOrABdUxI7yp2hbH6F%2FromTe5Aj7qD0a0GebBgpOKu8z5WSaLMSkAOaLYEh%2BMgBQj2OJtSCt%2B1TkQpLx1yPPDhSF%2FoyGP29C0TXe%2Fs7EkP8MCwijki02ZqWh245T4oFePkv1311rpdwqMdvdQaA43sPhdv63SivCj2MhHzo7KBeTUwfOsulhSTqoWTbhkbZsej3IZ%2Bp56aov2pmM8RK898F3nnClVVYH%2FsynSHZ0xzb0e7Bs%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZ5D4I2SS%2F20260426%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260426T184802Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0b6dfbf8e6d3fda22d30ae80ae655feb954cb870fd9ca476b7a06b40fa55e4bf 300w\" sizes=\"auto, (max-width: 390px) 100vw, 390px\" \/><\/p>\n<h1>Greater Than or Equal To &gt;=<\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-376\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133435\/DB4SQL-filters-7b.png\" alt=\"\" width=\"389\" height=\"210\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133435\/DB4SQL-filters-7b.png 389w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133435\/DB4SQL-filters-7b-300x162.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEOv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQC%2Fl9xeM%2Ffay%2BfL6bv%2BR2qOl22RLpgvbzOXt%2F47YSTZKwIhAJ7nN%2FD8dQ4sQowOietmOGstlZ%2FVb1Nx9asPJe9c5TQbKsEFCLT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQBRoMMjczNTcwMTk1NDMzIgzFepxoCffCWsvfQ5cqlQXV6H8pqRxR%2F8FBTNoE07wvSQ2WBB8zMdtSds%2B%2BuS%2BALcgPxD16USq659qOEW8KxdBnwOsnR264Mjkpdm4XMjyALKCd%2FeHGzRCyMxz7BVLXVMlTm4d6Ckppq3EO2kQB4K8oqb8QkbU9gK6LTKl1%2BrSQxVxOG4Org6xlOcGZs0hEJfTyZLF3L%2B1KQDQn9dWzMu6pev4nZsat2WtegVhbOWqjEWiLiKyGKFhQYkJs8h1PkERSfUJfXFWk%2BdoZ5yA8H9lEesEyeUg1LaRAsYESASb4ZKPvkcEL8OA%2Bsa4Qy63BEx%2BU2KUmj9NF7vR%2BjU8g06VW%2Bb5gGLoZHZr%2BJw9hBp5XqCV3I7wQse1K3iltXO58gFPqqYiyFrku6kr6GZ8tuqpPPmgQ%2BVotPZqlxYHbTZOQ%2FmldzhoI367fdohNkrwOx3IfSAQE7EdaLY3Ln%2B2PP9YYOr5f0Djgl1Lp7LLfZEcHlbblpVp%2FbqcURjxbt86x8GW%2B1nZhprTI1S2qr19XcOL8Rjjurz%2BYdcWVe0SNVGl8YWc0oOyPxokTxkgnrOXaHrhrLAa9IVscL%2Frj0cOITHZTwhNcx%2FYKFvM4K5TrTJ57RICzJ2QSttWx5jP9qtgMRi5JP0oi2qTgpBFyH3U27GY9YewCYWX8JJveLVCVyTYjScqvQ4Ua7cPD2Iw4TI18SZBX8nm5mcEX2y0hlyM5zpCcx0nz4mzvOltyTZZvbQK5G9jV%2FLjL5bmp8t9pf213ltdIyRKML5K3M1kitkv91gnFViieIH5ecqdUI8j7ya9yfxE9TroWEooVNZnmitqO2N1BF%2Fj1tkkw8znx9%2BRyxLj8gSf%2BHtAdQ8NlKszR%2BUeL3D17PnUIVdAVa5gRVE4FqlKWpnExMIywuc8GOrABdUxI7yp2hbH6F%2FromTe5Aj7qD0a0GebBgpOKu8z5WSaLMSkAOaLYEh%2BMgBQj2OJtSCt%2B1TkQpLx1yPPDhSF%2FoyGP29C0TXe%2Fs7EkP8MCwijki02ZqWh245T4oFePkv1311rpdwqMdvdQaA43sPhdv63SivCj2MhHzo7KBeTUwfOsulhSTqoWTbhkbZsej3IZ%2Bp56aov2pmM8RK898F3nnClVVYH%2FsynSHZ0xzb0e7Bs%3D&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UZ5D4I2SS%2F20260426%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260426T184802Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=42f23710c93624285e80f032bad9a3b0ac069a891fe2c55ed6f3a46160a76fce 300w\" sizes=\"auto, (max-width: 389px) 100vw, 389px\" \/><\/p>\n<h2>Dates &amp; Times<\/h2>\n<p>The same symbols can be used with dates and times.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-374\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25133432\/DB4SQL-filters-6c.png\" alt=\"\" width=\"262\" height=\"133\" \/><\/p>\n<h1><\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Instead of manually looking through all records, filters can be created to only display records that match conditions. Click on the &#8220;Browse Data&#8221; tab, and select the table to edit: &nbsp; At the top of each column are empty filters &#8211; typing into these will restrict which records are displayed: Simple Text Filters Typing in text (letters or numbers) will only show the records that contain that text anywhere in<\/p>\n<p><a class=\"more-link\" href=\"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/national-4\/filtering-records\/\">Read More<\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"parent":226,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-252","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/comments?post=252"}],"version-history":[{"count":9,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/252\/revisions"}],"predecessor-version":[{"id":381,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/252\/revisions\/381"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/226"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/media?parent=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}